Skip to main content
Version: 8.4.12.1

SecDefRequestGateway

V8 Message Definiton

METADATA

AttributeValue
Topic5120-srse-gateway
MLink TokenInternal
ProductSRTrade
accessTypeSELECT,INSERT

Table Definition

FieldTypeKeyDefault ValueComment
secRequestIDBIGINTPRI0
secDefTypeenum - SecDefType'None'
accntVARCHAR(16)''routing code of exchange session handling product def request
clientFirmVARCHAR(16)''
altRequestIdVARCHAR(24)''Alternate request ID Can by used by client for tracking
secKey1_atenum - AssetType'None'Symbol for leg 1 Must be a valid symbol
secKey1_tsenum - TickerSrc'None'Symbol for leg 1 Must be a valid symbol
secKey1_tkVARCHAR(12)''Symbol for leg 1 Must be a valid symbol
secKey1_yrSMALLINT UNSIGNED1900Symbol for leg 1 Must be a valid symbol
secKey1_mnTINYINT UNSIGNED0Symbol for leg 1 Must be a valid symbol
secKey1_dyTINYINT UNSIGNED0Symbol for leg 1 Must be a valid symbol
secKey1_xxDOUBLE0Symbol for leg 1 Must be a valid symbol
secKey1_cpenum - CallPut'Call'Symbol for leg 1 Must be a valid symbol
secType1enum - SpdrKeyType'None'Security Type Stock Future Option
ratio1SMALLINT UNSIGNED0Ratio for leg 1 Must be greater than zero
side1enum - BuySell'Buy'Order side for leg 1
refPrc1DOUBLE0Reference price for leg 1
refDelta1FLOAT0Reference delta for leg 1
secKey2_atenum - AssetType'None'Symbol for leg 2 Must be a valid symbol
secKey2_tsenum - TickerSrc'None'Symbol for leg 2 Must be a valid symbol
secKey2_tkVARCHAR(12)''Symbol for leg 2 Must be a valid symbol
secKey2_yrSMALLINT UNSIGNED1900Symbol for leg 2 Must be a valid symbol
secKey2_mnTINYINT UNSIGNED0Symbol for leg 2 Must be a valid symbol
secKey2_dyTINYINT UNSIGNED0Symbol for leg 2 Must be a valid symbol
secKey2_xxDOUBLE0Symbol for leg 2 Must be a valid symbol
secKey2_cpenum - CallPut'Call'Symbol for leg 2 Must be a valid symbol
secType2enum - SpdrKeyType'None'Security Type Stock Future Option
ratio2SMALLINT UNSIGNED0Ratio for leg 2 Must be greater than zero
side2enum - BuySell'Buy'Order side for leg 2
refPrc2DOUBLE0Reference price for leg 2
refDelta2FLOAT0Reference delta for leg 2
secKey3_atenum - AssetType'None'Symbol for leg 3 Must be a valid symbol
secKey3_tsenum - TickerSrc'None'Symbol for leg 3 Must be a valid symbol
secKey3_tkVARCHAR(12)''Symbol for leg 3 Must be a valid symbol
secKey3_yrSMALLINT UNSIGNED1900Symbol for leg 3 Must be a valid symbol
secKey3_mnTINYINT UNSIGNED0Symbol for leg 3 Must be a valid symbol
secKey3_dyTINYINT UNSIGNED0Symbol for leg 3 Must be a valid symbol
secKey3_xxDOUBLE0Symbol for leg 3 Must be a valid symbol
secKey3_cpenum - CallPut'Call'Symbol for leg 3 Must be a valid symbol
secType3enum - SpdrKeyType'None'Security Type Stock Future Option
ratio3SMALLINT UNSIGNED0Ratio for leg 3 Must be greater than zero
side3enum - BuySell'Buy'Order side for leg 3
refPrc3DOUBLE0Reference price for leg 3
refDelta3FLOAT0Reference delta for leg 3
secKey4_atenum - AssetType'None'Symbol for leg 4 Must be a valid symbol
secKey4_tsenum - TickerSrc'None'Symbol for leg 4 Must be a valid symbol
secKey4_tkVARCHAR(12)''Symbol for leg 4 Must be a valid symbol
secKey4_yrSMALLINT UNSIGNED1900Symbol for leg 4 Must be a valid symbol
secKey4_mnTINYINT UNSIGNED0Symbol for leg 4 Must be a valid symbol
secKey4_dyTINYINT UNSIGNED0Symbol for leg 4 Must be a valid symbol
secKey4_xxDOUBLE0Symbol for leg 4 Must be a valid symbol
secKey4_cpenum - CallPut'Call'Symbol for leg 4 Must be a valid symbol
secType4enum - SpdrKeyType'None'Security Type Stock Future Option
ratio4SMALLINT UNSIGNED0Ratio for leg 4 Must be greater than zero
side4enum - BuySell'Buy'Order side for leg 4
refPrc4DOUBLE0Reference price for leg 4
refDelta4FLOAT0Reference delta for leg 4
secKey5_atenum - AssetType'None'Symbol for leg 5 Must be a valid symbol
secKey5_tsenum - TickerSrc'None'Symbol for leg 5 Must be a valid symbol
secKey5_tkVARCHAR(12)''Symbol for leg 5 Must be a valid symbol
secKey5_yrSMALLINT UNSIGNED1900Symbol for leg 5 Must be a valid symbol
secKey5_mnTINYINT UNSIGNED0Symbol for leg 5 Must be a valid symbol
secKey5_dyTINYINT UNSIGNED0Symbol for leg 5 Must be a valid symbol
secKey5_xxDOUBLE0Symbol for leg 5 Must be a valid symbol
secKey5_cpenum - CallPut'Call'Symbol for leg 5 Must be a valid symbol
secType5enum - SpdrKeyType'None'Security Type Stock Future Option
ratio5SMALLINT UNSIGNED0Ratio for leg 5 Must be greater than zero
side5enum - BuySell'Buy'Order side for leg 5
refPrc5DOUBLE0Reference price for leg 5
refDelta5FLOAT0Reference delta for leg 5
secKey6_atenum - AssetType'None'Symbol for leg 6 Must be a valid symbol
secKey6_tsenum - TickerSrc'None'Symbol for leg 6 Must be a valid symbol
secKey6_tkVARCHAR(12)''Symbol for leg 6 Must be a valid symbol
secKey6_yrSMALLINT UNSIGNED1900Symbol for leg 6 Must be a valid symbol
secKey6_mnTINYINT UNSIGNED0Symbol for leg 6 Must be a valid symbol
secKey6_dyTINYINT UNSIGNED0Symbol for leg 6 Must be a valid symbol
secKey6_xxDOUBLE0Symbol for leg 6 Must be a valid symbol
secKey6_cpenum - CallPut'Call'Symbol for leg 6 Must be a valid symbol
secType6enum - SpdrKeyType'None'Security Type Stock Future Option
ratio6SMALLINT UNSIGNED0Ratio for leg 6 Must be greater than zero
side6enum - BuySell'Buy'Order side for leg 6
refPrc6DOUBLE0Reference price for leg 6
refDelta6FLOAT0Reference delta for leg 6
secKey7_atenum - AssetType'None'Symbol for leg 7 Must be a valid symbol
secKey7_tsenum - TickerSrc'None'Symbol for leg 7 Must be a valid symbol
secKey7_tkVARCHAR(12)''Symbol for leg 7 Must be a valid symbol
secKey7_yrSMALLINT UNSIGNED1900Symbol for leg 7 Must be a valid symbol
secKey7_mnTINYINT UNSIGNED0Symbol for leg 7 Must be a valid symbol
secKey7_dyTINYINT UNSIGNED0Symbol for leg 7 Must be a valid symbol
secKey7_xxDOUBLE0Symbol for leg 7 Must be a valid symbol
secKey7_cpenum - CallPut'Call'Symbol for leg 7 Must be a valid symbol
secType7enum - SpdrKeyType'None'Security Type Stock Future Option
ratio7SMALLINT UNSIGNED0Ratio for leg 7 Must be greater than zero
side7enum - BuySell'Buy'Order side for leg 7
refPrc7DOUBLE0Reference price for leg 7
refDelta7FLOAT0Reference delta for leg 7
secKey8_atenum - AssetType'None'Symbol for leg 8 Must be a valid symbol
secKey8_tsenum - TickerSrc'None'Symbol for leg 8 Must be a valid symbol
secKey8_tkVARCHAR(12)''Symbol for leg 8 Must be a valid symbol
secKey8_yrSMALLINT UNSIGNED1900Symbol for leg 8 Must be a valid symbol
secKey8_mnTINYINT UNSIGNED0Symbol for leg 8 Must be a valid symbol
secKey8_dyTINYINT UNSIGNED0Symbol for leg 8 Must be a valid symbol
secKey8_xxDOUBLE0Symbol for leg 8 Must be a valid symbol
secKey8_cpenum - CallPut'Call'Symbol for leg 8 Must be a valid symbol
secType8enum - SpdrKeyType'None'Security Type Stock Future Option
ratio8SMALLINT UNSIGNED0Ratio for leg 8 Must be greater than zero
side8enum - BuySell'Buy'Order side for leg 8
refPrc8DOUBLE0Reference price for leg 8
refDelta8FLOAT0Reference delta for leg 8
secKey9_atenum - AssetType'None'Symbol for leg 9 Must be a valid symbol
secKey9_tsenum - TickerSrc'None'Symbol for leg 9 Must be a valid symbol
secKey9_tkVARCHAR(12)''Symbol for leg 9 Must be a valid symbol
secKey9_yrSMALLINT UNSIGNED1900Symbol for leg 9 Must be a valid symbol
secKey9_mnTINYINT UNSIGNED0Symbol for leg 9 Must be a valid symbol
secKey9_dyTINYINT UNSIGNED0Symbol for leg 9 Must be a valid symbol
secKey9_xxDOUBLE0Symbol for leg 9 Must be a valid symbol
secKey9_cpenum - CallPut'Call'Symbol for leg 9 Must be a valid symbol
secType9enum - SpdrKeyType'None'Security Type Stock Future Option
ratio9SMALLINT UNSIGNED0Ratio for leg 9 Must be greater than zero
side9enum - BuySell'Buy'Order side for leg 9
refPrc9DOUBLE0Reference price for leg 9
refDelta9FLOAT0Reference delta for leg 9
secKey10_atenum - AssetType'None'Symbol for leg 10 Must be a valid symbol
secKey10_tsenum - TickerSrc'None'Symbol for leg 10 Must be a valid symbol
secKey10_tkVARCHAR(12)''Symbol for leg 10 Must be a valid symbol
secKey10_yrSMALLINT UNSIGNED1900Symbol for leg 10 Must be a valid symbol
secKey10_mnTINYINT UNSIGNED0Symbol for leg 10 Must be a valid symbol
secKey10_dyTINYINT UNSIGNED0Symbol for leg 10 Must be a valid symbol
secKey10_xxDOUBLE0Symbol for leg 10 Must be a valid symbol
secKey10_cpenum - CallPut'Call'Symbol for leg 10 Must be a valid symbol
secType10enum - SpdrKeyType'None'Security Type Stock Future Option
ratio10SMALLINT UNSIGNED0Ratio for leg 10 Must be greater than zero
side10enum - BuySell'Buy'Order side for leg 10
refPrc10DOUBLE0Reference price for leg 10
refDelta10FLOAT0Reference delta for leg 10
secKey11_atenum - AssetType'None'Symbol for leg 11 Must be a valid symbol
secKey11_tsenum - TickerSrc'None'Symbol for leg 11 Must be a valid symbol
secKey11_tkVARCHAR(12)''Symbol for leg 11 Must be a valid symbol
secKey11_yrSMALLINT UNSIGNED1900Symbol for leg 11 Must be a valid symbol
secKey11_mnTINYINT UNSIGNED0Symbol for leg 11 Must be a valid symbol
secKey11_dyTINYINT UNSIGNED0Symbol for leg 11 Must be a valid symbol
secKey11_xxDOUBLE0Symbol for leg 11 Must be a valid symbol
secKey11_cpenum - CallPut'Call'Symbol for leg 11 Must be a valid symbol
secType11enum - SpdrKeyType'None'Security Type Stock Future Option
ratio11SMALLINT UNSIGNED0Ratio for leg 11 Must be greater than zero
side11enum - BuySell'Buy'Order side for leg 11
refPrc11DOUBLE0Reference price for leg 11
refDelta11FLOAT0Reference delta for leg 11
secKey12_atenum - AssetType'None'Symbol for leg 12 Must be a valid symbol
secKey12_tsenum - TickerSrc'None'Symbol for leg 12 Must be a valid symbol
secKey12_tkVARCHAR(12)''Symbol for leg 12 Must be a valid symbol
secKey12_yrSMALLINT UNSIGNED1900Symbol for leg 12 Must be a valid symbol
secKey12_mnTINYINT UNSIGNED0Symbol for leg 12 Must be a valid symbol
secKey12_dyTINYINT UNSIGNED0Symbol for leg 12 Must be a valid symbol
secKey12_xxDOUBLE0Symbol for leg 12 Must be a valid symbol
secKey12_cpenum - CallPut'Call'Symbol for leg 12 Must be a valid symbol
secType12enum - SpdrKeyType'None'Security Type Stock Future Option
ratio12SMALLINT UNSIGNED0Ratio for leg 12 Must be greater than zero
side12enum - BuySell'Buy'Order side for leg 12
refPrc12DOUBLE0Reference price for leg 12
refDelta12FLOAT0Reference delta for leg 12
secKey13_atenum - AssetType'None'Symbol for leg 13 Must be a valid symbol
secKey13_tsenum - TickerSrc'None'Symbol for leg 13 Must be a valid symbol
secKey13_tkVARCHAR(12)''Symbol for leg 13 Must be a valid symbol
secKey13_yrSMALLINT UNSIGNED1900Symbol for leg 13 Must be a valid symbol
secKey13_mnTINYINT UNSIGNED0Symbol for leg 13 Must be a valid symbol
secKey13_dyTINYINT UNSIGNED0Symbol for leg 13 Must be a valid symbol
secKey13_xxDOUBLE0Symbol for leg 13 Must be a valid symbol
secKey13_cpenum - CallPut'Call'Symbol for leg 13 Must be a valid symbol
secType13enum - SpdrKeyType'None'Security Type Stock Future Option
ratio13SMALLINT UNSIGNED0Ratio for leg 13 Must be greater than zero
side13enum - BuySell'Buy'Order side for leg 13
refPrc13DOUBLE0Reference price for leg 13
refDelta13FLOAT0Reference delta for leg 13
secKey14_atenum - AssetType'None'Symbol for leg 14 Must be a valid symbol
secKey14_tsenum - TickerSrc'None'Symbol for leg 14 Must be a valid symbol
secKey14_tkVARCHAR(12)''Symbol for leg 14 Must be a valid symbol
secKey14_yrSMALLINT UNSIGNED1900Symbol for leg 14 Must be a valid symbol
secKey14_mnTINYINT UNSIGNED0Symbol for leg 14 Must be a valid symbol
secKey14_dyTINYINT UNSIGNED0Symbol for leg 14 Must be a valid symbol
secKey14_xxDOUBLE0Symbol for leg 14 Must be a valid symbol
secKey14_cpenum - CallPut'Call'Symbol for leg 14 Must be a valid symbol
secType14enum - SpdrKeyType'None'Security Type Stock Future Option
ratio14SMALLINT UNSIGNED0Ratio for leg 14 Must be greater than zero
side14enum - BuySell'Buy'Order side for leg 14
refPrc14DOUBLE0Reference price for leg 14
refDelta14FLOAT0Reference delta for leg 14
secKey15_atenum - AssetType'None'Symbol for leg 15 Must be a valid symbol
secKey15_tsenum - TickerSrc'None'Symbol for leg 15 Must be a valid symbol
secKey15_tkVARCHAR(12)''Symbol for leg 15 Must be a valid symbol
secKey15_yrSMALLINT UNSIGNED1900Symbol for leg 15 Must be a valid symbol
secKey15_mnTINYINT UNSIGNED0Symbol for leg 15 Must be a valid symbol
secKey15_dyTINYINT UNSIGNED0Symbol for leg 15 Must be a valid symbol
secKey15_xxDOUBLE0Symbol for leg 15 Must be a valid symbol
secKey15_cpenum - CallPut'Call'Symbol for leg 15 Must be a valid symbol
secType15enum - SpdrKeyType'None'Security Type Stock Future Option
ratio15SMALLINT UNSIGNED0Ratio for leg 15 Must be greater than zero
side15enum - BuySell'Buy'Order side for leg 15
refPrc15DOUBLE0Reference price for leg 15
refDelta15FLOAT0Reference delta for leg 15
secKey16_atenum - AssetType'None'Symbol for leg 16 Must be a valid symbol
secKey16_tsenum - TickerSrc'None'Symbol for leg 16 Must be a valid symbol
secKey16_tkVARCHAR(12)''Symbol for leg 16 Must be a valid symbol
secKey16_yrSMALLINT UNSIGNED1900Symbol for leg 16 Must be a valid symbol
secKey16_mnTINYINT UNSIGNED0Symbol for leg 16 Must be a valid symbol
secKey16_dyTINYINT UNSIGNED0Symbol for leg 16 Must be a valid symbol
secKey16_xxDOUBLE0Symbol for leg 16 Must be a valid symbol
secKey16_cpenum - CallPut'Call'Symbol for leg 16 Must be a valid symbol
secType16enum - SpdrKeyType'None'Security Type Stock Future Option
ratio16SMALLINT UNSIGNED0Ratio for leg 16 Must be greater than zero
side16enum - BuySell'Buy'Order side for leg 16
refPrc16DOUBLE0Reference price for leg 16
refDelta16FLOAT0Reference delta for leg 16
secKey17_atenum - AssetType'None'Symbol for leg 17 Must be a valid symbol
secKey17_tsenum - TickerSrc'None'Symbol for leg 17 Must be a valid symbol
secKey17_tkVARCHAR(12)''Symbol for leg 17 Must be a valid symbol
secKey17_yrSMALLINT UNSIGNED1900Symbol for leg 17 Must be a valid symbol
secKey17_mnTINYINT UNSIGNED0Symbol for leg 17 Must be a valid symbol
secKey17_dyTINYINT UNSIGNED0Symbol for leg 17 Must be a valid symbol
secKey17_xxDOUBLE0Symbol for leg 17 Must be a valid symbol
secKey17_cpenum - CallPut'Call'Symbol for leg 17 Must be a valid symbol
secType17enum - SpdrKeyType'None'Security Type Stock Future Option
ratio17SMALLINT UNSIGNED0Ratio for leg 17 Must be greater than zero
side17enum - BuySell'Buy'Order side for leg 17
refPrc17DOUBLE0Reference price for leg 17
refDelta17FLOAT0Reference delta for leg 17
secKey18_atenum - AssetType'None'Symbol for leg 18 Must be a valid symbol
secKey18_tsenum - TickerSrc'None'Symbol for leg 18 Must be a valid symbol
secKey18_tkVARCHAR(12)''Symbol for leg 18 Must be a valid symbol
secKey18_yrSMALLINT UNSIGNED1900Symbol for leg 18 Must be a valid symbol
secKey18_mnTINYINT UNSIGNED0Symbol for leg 18 Must be a valid symbol
secKey18_dyTINYINT UNSIGNED0Symbol for leg 18 Must be a valid symbol
secKey18_xxDOUBLE0Symbol for leg 18 Must be a valid symbol
secKey18_cpenum - CallPut'Call'Symbol for leg 18 Must be a valid symbol
secType18enum - SpdrKeyType'None'Security Type Stock Future Option
ratio18SMALLINT UNSIGNED0Ratio for leg 18 Must be greater than zero
side18enum - BuySell'Buy'Order side for leg 18
refPrc18DOUBLE0Reference price for leg 18
refDelta18FLOAT0Reference delta for leg 18
secKey19_atenum - AssetType'None'Symbol for leg 19 Must be a valid symbol
secKey19_tsenum - TickerSrc'None'Symbol for leg 19 Must be a valid symbol
secKey19_tkVARCHAR(12)''Symbol for leg 19 Must be a valid symbol
secKey19_yrSMALLINT UNSIGNED1900Symbol for leg 19 Must be a valid symbol
secKey19_mnTINYINT UNSIGNED0Symbol for leg 19 Must be a valid symbol
secKey19_dyTINYINT UNSIGNED0Symbol for leg 19 Must be a valid symbol
secKey19_xxDOUBLE0Symbol for leg 19 Must be a valid symbol
secKey19_cpenum - CallPut'Call'Symbol for leg 19 Must be a valid symbol
secType19enum - SpdrKeyType'None'Security Type Stock Future Option
ratio19SMALLINT UNSIGNED0Ratio for leg 19 Must be greater than zero
side19enum - BuySell'Buy'Order side for leg 19
refPrc19DOUBLE0Reference price for leg 19
refDelta19FLOAT0Reference delta for leg 19
secKey20_atenum - AssetType'None'Symbol for leg 20 Must be a valid symbol
secKey20_tsenum - TickerSrc'None'Symbol for leg 20 Must be a valid symbol
secKey20_tkVARCHAR(12)''Symbol for leg 20 Must be a valid symbol
secKey20_yrSMALLINT UNSIGNED1900Symbol for leg 20 Must be a valid symbol
secKey20_mnTINYINT UNSIGNED0Symbol for leg 20 Must be a valid symbol
secKey20_dyTINYINT UNSIGNED0Symbol for leg 20 Must be a valid symbol
secKey20_xxDOUBLE0Symbol for leg 20 Must be a valid symbol
secKey20_cpenum - CallPut'Call'Symbol for leg 20 Must be a valid symbol
secType20enum - SpdrKeyType'None'Security Type Stock Future Option
ratio20SMALLINT UNSIGNED0Ratio for leg 20 Must be greater than zero
side20enum - BuySell'Buy'Order side for leg 20
refPrc20DOUBLE0Reference price for leg 20
refDelta20FLOAT0Reference delta for leg 20
modifiedByVARCHAR(24)''user who last modified this record
modifiedInenum - SysEnvironment'None'
timestampDATETIME(6)'1900-01-01 00:00:00.000000'timestamp of last modification

PRIMARY KEY DEFINITION (Unique)

FieldSequence
secRequestID1

CREATE TABLE EXAMPLE QUERY

CREATE TABLE `SRTrade`.`MsgSecDefRequestGateway` (
`secRequestID` BIGINT NOT NULL DEFAULT 0,
`secDefType` ENUM('None','Covered','Combo') NOT NULL DEFAULT 'None',
`accnt` VARCHAR(16) NOT NULL DEFAULT '' COMMENT 'routing code of exchange session handling product def request',
`clientFirm` VARCHAR(16) NOT NULL DEFAULT '',
`altRequestId` VARCHAR(24) NOT NULL DEFAULT '' COMMENT 'Alternate request ID. Can by used by client for tracking',
`secKey1_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #1. Must be a valid symbol.',
`secKey1_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #1. Must be a valid symbol.',
`secKey1_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'Symbol for leg #1. Must be a valid symbol.',
`secKey1_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 1900 COMMENT 'Symbol for leg #1. Must be a valid symbol.',
`secKey1_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #1. Must be a valid symbol.',
`secKey1_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #1. Must be a valid symbol.',
`secKey1_xx` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #1. Must be a valid symbol.',
`secKey1_cp` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Call' COMMENT 'Symbol for leg #1. Must be a valid symbol.',
`secType1` ENUM('None','Stock','Future','Option','MLeg') NOT NULL DEFAULT 'None' COMMENT 'Security Type [Stock, Future, Option]',
`ratio1` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Ratio for leg #1. Must be greater than zero.',
`side1` ENUM('Buy','Sell') NOT NULL DEFAULT 'Buy' COMMENT 'Order side for leg #1.',
`refPrc1` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Reference price for leg #1.',
`refDelta1` FLOAT NOT NULL DEFAULT 0 COMMENT 'Reference delta for leg #1.',
`secKey2_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #2. Must be a valid symbol.',
`secKey2_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #2. Must be a valid symbol.',
`secKey2_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'Symbol for leg #2. Must be a valid symbol.',
`secKey2_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 1900 COMMENT 'Symbol for leg #2. Must be a valid symbol.',
`secKey2_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #2. Must be a valid symbol.',
`secKey2_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #2. Must be a valid symbol.',
`secKey2_xx` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #2. Must be a valid symbol.',
`secKey2_cp` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Call' COMMENT 'Symbol for leg #2. Must be a valid symbol.',
`secType2` ENUM('None','Stock','Future','Option','MLeg') NOT NULL DEFAULT 'None' COMMENT 'Security Type [Stock, Future, Option]',
`ratio2` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Ratio for leg #2. Must be greater than zero.',
`side2` ENUM('Buy','Sell') NOT NULL DEFAULT 'Buy' COMMENT 'Order side for leg #2.',
`refPrc2` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Reference price for leg #2.',
`refDelta2` FLOAT NOT NULL DEFAULT 0 COMMENT 'Reference delta for leg #2.',
`secKey3_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #3. Must be a valid symbol.',
`secKey3_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #3. Must be a valid symbol.',
`secKey3_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'Symbol for leg #3. Must be a valid symbol.',
`secKey3_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 1900 COMMENT 'Symbol for leg #3. Must be a valid symbol.',
`secKey3_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #3. Must be a valid symbol.',
`secKey3_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #3. Must be a valid symbol.',
`secKey3_xx` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #3. Must be a valid symbol.',
`secKey3_cp` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Call' COMMENT 'Symbol for leg #3. Must be a valid symbol.',
`secType3` ENUM('None','Stock','Future','Option','MLeg') NOT NULL DEFAULT 'None' COMMENT 'Security Type [Stock, Future, Option]',
`ratio3` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Ratio for leg #3. Must be greater than zero.',
`side3` ENUM('Buy','Sell') NOT NULL DEFAULT 'Buy' COMMENT 'Order side for leg #3.',
`refPrc3` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Reference price for leg #3.',
`refDelta3` FLOAT NOT NULL DEFAULT 0 COMMENT 'Reference delta for leg #3.',
`secKey4_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #4. Must be a valid symbol.',
`secKey4_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #4. Must be a valid symbol.',
`secKey4_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'Symbol for leg #4. Must be a valid symbol.',
`secKey4_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 1900 COMMENT 'Symbol for leg #4. Must be a valid symbol.',
`secKey4_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #4. Must be a valid symbol.',
`secKey4_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #4. Must be a valid symbol.',
`secKey4_xx` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #4. Must be a valid symbol.',
`secKey4_cp` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Call' COMMENT 'Symbol for leg #4. Must be a valid symbol.',
`secType4` ENUM('None','Stock','Future','Option','MLeg') NOT NULL DEFAULT 'None' COMMENT 'Security Type [Stock, Future, Option]',
`ratio4` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Ratio for leg #4. Must be greater than zero.',
`side4` ENUM('Buy','Sell') NOT NULL DEFAULT 'Buy' COMMENT 'Order side for leg #4.',
`refPrc4` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Reference price for leg #4.',
`refDelta4` FLOAT NOT NULL DEFAULT 0 COMMENT 'Reference delta for leg #4.',
`secKey5_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #5. Must be a valid symbol.',
`secKey5_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #5. Must be a valid symbol.',
`secKey5_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'Symbol for leg #5. Must be a valid symbol.',
`secKey5_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 1900 COMMENT 'Symbol for leg #5. Must be a valid symbol.',
`secKey5_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #5. Must be a valid symbol.',
`secKey5_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #5. Must be a valid symbol.',
`secKey5_xx` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #5. Must be a valid symbol.',
`secKey5_cp` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Call' COMMENT 'Symbol for leg #5. Must be a valid symbol.',
`secType5` ENUM('None','Stock','Future','Option','MLeg') NOT NULL DEFAULT 'None' COMMENT 'Security Type [Stock, Future, Option]',
`ratio5` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Ratio for leg #5. Must be greater than zero.',
`side5` ENUM('Buy','Sell') NOT NULL DEFAULT 'Buy' COMMENT 'Order side for leg #5.',
`refPrc5` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Reference price for leg #5.',
`refDelta5` FLOAT NOT NULL DEFAULT 0 COMMENT 'Reference delta for leg #5.',
`secKey6_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #6. Must be a valid symbol.',
`secKey6_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #6. Must be a valid symbol.',
`secKey6_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'Symbol for leg #6. Must be a valid symbol.',
`secKey6_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 1900 COMMENT 'Symbol for leg #6. Must be a valid symbol.',
`secKey6_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #6. Must be a valid symbol.',
`secKey6_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #6. Must be a valid symbol.',
`secKey6_xx` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #6. Must be a valid symbol.',
`secKey6_cp` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Call' COMMENT 'Symbol for leg #6. Must be a valid symbol.',
`secType6` ENUM('None','Stock','Future','Option','MLeg') NOT NULL DEFAULT 'None' COMMENT 'Security Type [Stock, Future, Option]',
`ratio6` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Ratio for leg #6. Must be greater than zero.',
`side6` ENUM('Buy','Sell') NOT NULL DEFAULT 'Buy' COMMENT 'Order side for leg #6.',
`refPrc6` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Reference price for leg #6.',
`refDelta6` FLOAT NOT NULL DEFAULT 0 COMMENT 'Reference delta for leg #6.',
`secKey7_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #7. Must be a valid symbol.',
`secKey7_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #7. Must be a valid symbol.',
`secKey7_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'Symbol for leg #7. Must be a valid symbol.',
`secKey7_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 1900 COMMENT 'Symbol for leg #7. Must be a valid symbol.',
`secKey7_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #7. Must be a valid symbol.',
`secKey7_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #7. Must be a valid symbol.',
`secKey7_xx` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #7. Must be a valid symbol.',
`secKey7_cp` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Call' COMMENT 'Symbol for leg #7. Must be a valid symbol.',
`secType7` ENUM('None','Stock','Future','Option','MLeg') NOT NULL DEFAULT 'None' COMMENT 'Security Type [Stock, Future, Option]',
`ratio7` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Ratio for leg #7. Must be greater than zero.',
`side7` ENUM('Buy','Sell') NOT NULL DEFAULT 'Buy' COMMENT 'Order side for leg #7.',
`refPrc7` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Reference price for leg #7.',
`refDelta7` FLOAT NOT NULL DEFAULT 0 COMMENT 'Reference delta for leg #7.',
`secKey8_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #8. Must be a valid symbol.',
`secKey8_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #8. Must be a valid symbol.',
`secKey8_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'Symbol for leg #8. Must be a valid symbol.',
`secKey8_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 1900 COMMENT 'Symbol for leg #8. Must be a valid symbol.',
`secKey8_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #8. Must be a valid symbol.',
`secKey8_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #8. Must be a valid symbol.',
`secKey8_xx` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #8. Must be a valid symbol.',
`secKey8_cp` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Call' COMMENT 'Symbol for leg #8. Must be a valid symbol.',
`secType8` ENUM('None','Stock','Future','Option','MLeg') NOT NULL DEFAULT 'None' COMMENT 'Security Type [Stock, Future, Option]',
`ratio8` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Ratio for leg #8. Must be greater than zero.',
`side8` ENUM('Buy','Sell') NOT NULL DEFAULT 'Buy' COMMENT 'Order side for leg #8.',
`refPrc8` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Reference price for leg #8.',
`refDelta8` FLOAT NOT NULL DEFAULT 0 COMMENT 'Reference delta for leg #8.',
`secKey9_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #9. Must be a valid symbol.',
`secKey9_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #9. Must be a valid symbol.',
`secKey9_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'Symbol for leg #9. Must be a valid symbol.',
`secKey9_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 1900 COMMENT 'Symbol for leg #9. Must be a valid symbol.',
`secKey9_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #9. Must be a valid symbol.',
`secKey9_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #9. Must be a valid symbol.',
`secKey9_xx` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #9. Must be a valid symbol.',
`secKey9_cp` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Call' COMMENT 'Symbol for leg #9. Must be a valid symbol.',
`secType9` ENUM('None','Stock','Future','Option','MLeg') NOT NULL DEFAULT 'None' COMMENT 'Security Type [Stock, Future, Option]',
`ratio9` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Ratio for leg #9. Must be greater than zero.',
`side9` ENUM('Buy','Sell') NOT NULL DEFAULT 'Buy' COMMENT 'Order side for leg #9.',
`refPrc9` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Reference price for leg #9.',
`refDelta9` FLOAT NOT NULL DEFAULT 0 COMMENT 'Reference delta for leg #9.',
`secKey10_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #10. Must be a valid symbol.',
`secKey10_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #10. Must be a valid symbol.',
`secKey10_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'Symbol for leg #10. Must be a valid symbol.',
`secKey10_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 1900 COMMENT 'Symbol for leg #10. Must be a valid symbol.',
`secKey10_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #10. Must be a valid symbol.',
`secKey10_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #10. Must be a valid symbol.',
`secKey10_xx` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #10. Must be a valid symbol.',
`secKey10_cp` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Call' COMMENT 'Symbol for leg #10. Must be a valid symbol.',
`secType10` ENUM('None','Stock','Future','Option','MLeg') NOT NULL DEFAULT 'None' COMMENT 'Security Type [Stock, Future, Option]',
`ratio10` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Ratio for leg #10. Must be greater than zero.',
`side10` ENUM('Buy','Sell') NOT NULL DEFAULT 'Buy' COMMENT 'Order side for leg #10.',
`refPrc10` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Reference price for leg #10.',
`refDelta10` FLOAT NOT NULL DEFAULT 0 COMMENT 'Reference delta for leg #10.',
`secKey11_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #11. Must be a valid symbol.',
`secKey11_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #11. Must be a valid symbol.',
`secKey11_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'Symbol for leg #11. Must be a valid symbol.',
`secKey11_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 1900 COMMENT 'Symbol for leg #11. Must be a valid symbol.',
`secKey11_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #11. Must be a valid symbol.',
`secKey11_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #11. Must be a valid symbol.',
`secKey11_xx` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #11. Must be a valid symbol.',
`secKey11_cp` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Call' COMMENT 'Symbol for leg #11. Must be a valid symbol.',
`secType11` ENUM('None','Stock','Future','Option','MLeg') NOT NULL DEFAULT 'None' COMMENT 'Security Type [Stock, Future, Option]',
`ratio11` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Ratio for leg #11. Must be greater than zero.',
`side11` ENUM('Buy','Sell') NOT NULL DEFAULT 'Buy' COMMENT 'Order side for leg 1#1.',
`refPrc11` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Reference price for leg #11.',
`refDelta11` FLOAT NOT NULL DEFAULT 0 COMMENT 'Reference delta for leg #11.',
`secKey12_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #12. Must be a valid symbol.',
`secKey12_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #12. Must be a valid symbol.',
`secKey12_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'Symbol for leg #12. Must be a valid symbol.',
`secKey12_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 1900 COMMENT 'Symbol for leg #12. Must be a valid symbol.',
`secKey12_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #12. Must be a valid symbol.',
`secKey12_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #12. Must be a valid symbol.',
`secKey12_xx` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #12. Must be a valid symbol.',
`secKey12_cp` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Call' COMMENT 'Symbol for leg #12. Must be a valid symbol.',
`secType12` ENUM('None','Stock','Future','Option','MLeg') NOT NULL DEFAULT 'None' COMMENT 'Security Type [Stock, Future, Option]',
`ratio12` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Ratio for leg #12. Must be greater than zero.',
`side12` ENUM('Buy','Sell') NOT NULL DEFAULT 'Buy' COMMENT 'Order side for leg #12.',
`refPrc12` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Reference price for leg #12.',
`refDelta12` FLOAT NOT NULL DEFAULT 0 COMMENT 'Reference delta for leg #12.',
`secKey13_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #13. Must be a valid symbol.',
`secKey13_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #13. Must be a valid symbol.',
`secKey13_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'Symbol for leg #13. Must be a valid symbol.',
`secKey13_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 1900 COMMENT 'Symbol for leg #13. Must be a valid symbol.',
`secKey13_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #13. Must be a valid symbol.',
`secKey13_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #13. Must be a valid symbol.',
`secKey13_xx` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #13. Must be a valid symbol.',
`secKey13_cp` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Call' COMMENT 'Symbol for leg #13. Must be a valid symbol.',
`secType13` ENUM('None','Stock','Future','Option','MLeg') NOT NULL DEFAULT 'None' COMMENT 'Security Type [Stock, Future, Option]',
`ratio13` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Ratio for leg #13. Must be greater than zero.',
`side13` ENUM('Buy','Sell') NOT NULL DEFAULT 'Buy' COMMENT 'Order side for leg #13.',
`refPrc13` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Reference price for leg #13.',
`refDelta13` FLOAT NOT NULL DEFAULT 0 COMMENT 'Reference delta for leg #13.',
`secKey14_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #14. Must be a valid symbol.',
`secKey14_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #14. Must be a valid symbol.',
`secKey14_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'Symbol for leg #14. Must be a valid symbol.',
`secKey14_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 1900 COMMENT 'Symbol for leg #14. Must be a valid symbol.',
`secKey14_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #14. Must be a valid symbol.',
`secKey14_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #14. Must be a valid symbol.',
`secKey14_xx` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #14. Must be a valid symbol.',
`secKey14_cp` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Call' COMMENT 'Symbol for leg #14. Must be a valid symbol.',
`secType14` ENUM('None','Stock','Future','Option','MLeg') NOT NULL DEFAULT 'None' COMMENT 'Security Type [Stock, Future, Option]',
`ratio14` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Ratio for leg 1#4. Must be greater than zero.',
`side14` ENUM('Buy','Sell') NOT NULL DEFAULT 'Buy' COMMENT 'Order side for leg #14.',
`refPrc14` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Reference price for leg #14.',
`refDelta14` FLOAT NOT NULL DEFAULT 0 COMMENT 'Reference delta for leg #14.',
`secKey15_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #15. Must be a valid symbol.',
`secKey15_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #15. Must be a valid symbol.',
`secKey15_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'Symbol for leg #15. Must be a valid symbol.',
`secKey15_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 1900 COMMENT 'Symbol for leg #15. Must be a valid symbol.',
`secKey15_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #15. Must be a valid symbol.',
`secKey15_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #15. Must be a valid symbol.',
`secKey15_xx` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #15. Must be a valid symbol.',
`secKey15_cp` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Call' COMMENT 'Symbol for leg #15. Must be a valid symbol.',
`secType15` ENUM('None','Stock','Future','Option','MLeg') NOT NULL DEFAULT 'None' COMMENT 'Security Type [Stock, Future, Option]',
`ratio15` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Ratio for leg #15. Must be greater than zero.',
`side15` ENUM('Buy','Sell') NOT NULL DEFAULT 'Buy' COMMENT 'Order side for leg #15.',
`refPrc15` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Reference price for leg #15.',
`refDelta15` FLOAT NOT NULL DEFAULT 0 COMMENT 'Reference delta for leg #15.',
`secKey16_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #16. Must be a valid symbol.',
`secKey16_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #16. Must be a valid symbol.',
`secKey16_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'Symbol for leg #16. Must be a valid symbol.',
`secKey16_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 1900 COMMENT 'Symbol for leg #16. Must be a valid symbol.',
`secKey16_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #16. Must be a valid symbol.',
`secKey16_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #16. Must be a valid symbol.',
`secKey16_xx` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #16. Must be a valid symbol.',
`secKey16_cp` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Call' COMMENT 'Symbol for leg #16. Must be a valid symbol.',
`secType16` ENUM('None','Stock','Future','Option','MLeg') NOT NULL DEFAULT 'None' COMMENT 'Security Type [Stock, Future, Option]',
`ratio16` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Ratio for leg #16. Must be greater than zero.',
`side16` ENUM('Buy','Sell') NOT NULL DEFAULT 'Buy' COMMENT 'Order side for leg #16.',
`refPrc16` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Reference price for leg #16.',
`refDelta16` FLOAT NOT NULL DEFAULT 0 COMMENT 'Reference delta for leg #16.',
`secKey17_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #17. Must be a valid symbol.',
`secKey17_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #17. Must be a valid symbol.',
`secKey17_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'Symbol for leg #17. Must be a valid symbol.',
`secKey17_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 1900 COMMENT 'Symbol for leg #17. Must be a valid symbol.',
`secKey17_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #17. Must be a valid symbol.',
`secKey17_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #17. Must be a valid symbol.',
`secKey17_xx` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #17. Must be a valid symbol.',
`secKey17_cp` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Call' COMMENT 'Symbol for leg #17. Must be a valid symbol.',
`secType17` ENUM('None','Stock','Future','Option','MLeg') NOT NULL DEFAULT 'None' COMMENT 'Security Type [Stock, Future, Option]',
`ratio17` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Ratio for leg #17. Must be greater than zero.',
`side17` ENUM('Buy','Sell') NOT NULL DEFAULT 'Buy' COMMENT 'Order side for leg #17.',
`refPrc17` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Reference price for leg #17.',
`refDelta17` FLOAT NOT NULL DEFAULT 0 COMMENT 'Reference delta for leg #17.',
`secKey18_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #18. Must be a valid symbol.',
`secKey18_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #18. Must be a valid symbol.',
`secKey18_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'Symbol for leg #18. Must be a valid symbol.',
`secKey18_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 1900 COMMENT 'Symbol for leg #18. Must be a valid symbol.',
`secKey18_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #18. Must be a valid symbol.',
`secKey18_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #18. Must be a valid symbol.',
`secKey18_xx` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #18. Must be a valid symbol.',
`secKey18_cp` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Call' COMMENT 'Symbol for leg #18. Must be a valid symbol.',
`secType18` ENUM('None','Stock','Future','Option','MLeg') NOT NULL DEFAULT 'None' COMMENT 'Security Type [Stock, Future, Option]',
`ratio18` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Ratio for leg #18. Must be greater than zero.',
`side18` ENUM('Buy','Sell') NOT NULL DEFAULT 'Buy' COMMENT 'Order side for leg #18.',
`refPrc18` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Reference price for leg #18.',
`refDelta18` FLOAT NOT NULL DEFAULT 0 COMMENT 'Reference delta for leg #18.',
`secKey19_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #19. Must be a valid symbol.',
`secKey19_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #19. Must be a valid symbol.',
`secKey19_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'Symbol for leg #19. Must be a valid symbol.',
`secKey19_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 1900 COMMENT 'Symbol for leg #19. Must be a valid symbol.',
`secKey19_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #19. Must be a valid symbol.',
`secKey19_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #19. Must be a valid symbol.',
`secKey19_xx` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #19. Must be a valid symbol.',
`secKey19_cp` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Call' COMMENT 'Symbol for leg #19. Must be a valid symbol.',
`secType19` ENUM('None','Stock','Future','Option','MLeg') NOT NULL DEFAULT 'None' COMMENT 'Security Type [Stock, Future, Option]',
`ratio19` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Ratio for leg #19. Must be greater than zero.',
`side19` ENUM('Buy','Sell') NOT NULL DEFAULT 'Buy' COMMENT 'Order side for leg #19.',
`refPrc19` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Reference price for leg #19.',
`refDelta19` FLOAT NOT NULL DEFAULT 0 COMMENT 'Reference delta for leg #19.',
`secKey20_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #20. Must be a valid symbol.',
`secKey20_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'Symbol for leg #20. Must be a valid symbol.',
`secKey20_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'Symbol for leg #20. Must be a valid symbol.',
`secKey20_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 1900 COMMENT 'Symbol for leg #20. Must be a valid symbol.',
`secKey20_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #20. Must be a valid symbol.',
`secKey20_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #20. Must be a valid symbol.',
`secKey20_xx` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Symbol for leg #20. Must be a valid symbol.',
`secKey20_cp` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Call' COMMENT 'Symbol for leg #20. Must be a valid symbol.',
`secType20` ENUM('None','Stock','Future','Option','MLeg') NOT NULL DEFAULT 'None' COMMENT 'Security Type [Stock, Future, Option]',
`ratio20` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Ratio for leg #20. Must be greater than zero.',
`side20` ENUM('Buy','Sell') NOT NULL DEFAULT 'Buy' COMMENT 'Order side for leg #20.',
`refPrc20` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Reference price for leg #20.',
`refDelta20` FLOAT NOT NULL DEFAULT 0 COMMENT 'Reference delta for leg #20.',
`modifiedBy` VARCHAR(24) NOT NULL DEFAULT '' COMMENT 'user who last modified this record',
`modifiedIn` ENUM('None','Neptune','Pluto','V7_Stable','V7_Latest','Saturn','Venus','Mars','SysTest','V7_Current') NOT NULL DEFAULT 'None',
`timestamp` DATETIME(6) NOT NULL DEFAULT '1900-01-01 00:00:00.000000' COMMENT 'timestamp of last modification',
PRIMARY KEY USING HASH (`secRequestID`)
) ENGINE=SRSE DEFAULT CHARSET=LATIN1 COMMENT='';

SELECT TABLE EXAMPLE QUERY

SELECT
`secRequestID`,
`secDefType`,
`accnt`,
`clientFirm`,
`altRequestId`,
`secKey1_at`,
`secKey1_ts`,
`secKey1_tk`,
`secKey1_yr`,
`secKey1_mn`,
`secKey1_dy`,
`secKey1_xx`,
`secKey1_cp`,
`secType1`,
`ratio1`,
`side1`,
`refPrc1`,
`refDelta1`,
`secKey2_at`,
`secKey2_ts`,
`secKey2_tk`,
`secKey2_yr`,
`secKey2_mn`,
`secKey2_dy`,
`secKey2_xx`,
`secKey2_cp`,
`secType2`,
`ratio2`,
`side2`,
`refPrc2`,
`refDelta2`,
`secKey3_at`,
`secKey3_ts`,
`secKey3_tk`,
`secKey3_yr`,
`secKey3_mn`,
`secKey3_dy`,
`secKey3_xx`,
`secKey3_cp`,
`secType3`,
`ratio3`,
`side3`,
`refPrc3`,
`refDelta3`,
`secKey4_at`,
`secKey4_ts`,
`secKey4_tk`,
`secKey4_yr`,
`secKey4_mn`,
`secKey4_dy`,
`secKey4_xx`,
`secKey4_cp`,
`secType4`,
`ratio4`,
`side4`,
`refPrc4`,
`refDelta4`,
`secKey5_at`,
`secKey5_ts`,
`secKey5_tk`,
`secKey5_yr`,
`secKey5_mn`,
`secKey5_dy`,
`secKey5_xx`,
`secKey5_cp`,
`secType5`,
`ratio5`,
`side5`,
`refPrc5`,
`refDelta5`,
`secKey6_at`,
`secKey6_ts`,
`secKey6_tk`,
`secKey6_yr`,
`secKey6_mn`,
`secKey6_dy`,
`secKey6_xx`,
`secKey6_cp`,
`secType6`,
`ratio6`,
`side6`,
`refPrc6`,
`refDelta6`,
`secKey7_at`,
`secKey7_ts`,
`secKey7_tk`,
`secKey7_yr`,
`secKey7_mn`,
`secKey7_dy`,
`secKey7_xx`,
`secKey7_cp`,
`secType7`,
`ratio7`,
`side7`,
`refPrc7`,
`refDelta7`,
`secKey8_at`,
`secKey8_ts`,
`secKey8_tk`,
`secKey8_yr`,
`secKey8_mn`,
`secKey8_dy`,
`secKey8_xx`,
`secKey8_cp`,
`secType8`,
`ratio8`,
`side8`,
`refPrc8`,
`refDelta8`,
`secKey9_at`,
`secKey9_ts`,
`secKey9_tk`,
`secKey9_yr`,
`secKey9_mn`,
`secKey9_dy`,
`secKey9_xx`,
`secKey9_cp`,
`secType9`,
`ratio9`,
`side9`,
`refPrc9`,
`refDelta9`,
`secKey10_at`,
`secKey10_ts`,
`secKey10_tk`,
`secKey10_yr`,
`secKey10_mn`,
`secKey10_dy`,
`secKey10_xx`,
`secKey10_cp`,
`secType10`,
`ratio10`,
`side10`,
`refPrc10`,
`refDelta10`,
`secKey11_at`,
`secKey11_ts`,
`secKey11_tk`,
`secKey11_yr`,
`secKey11_mn`,
`secKey11_dy`,
`secKey11_xx`,
`secKey11_cp`,
`secType11`,
`ratio11`,
`side11`,
`refPrc11`,
`refDelta11`,
`secKey12_at`,
`secKey12_ts`,
`secKey12_tk`,
`secKey12_yr`,
`secKey12_mn`,
`secKey12_dy`,
`secKey12_xx`,
`secKey12_cp`,
`secType12`,
`ratio12`,
`side12`,
`refPrc12`,
`refDelta12`,
`secKey13_at`,
`secKey13_ts`,
`secKey13_tk`,
`secKey13_yr`,
`secKey13_mn`,
`secKey13_dy`,
`secKey13_xx`,
`secKey13_cp`,
`secType13`,
`ratio13`,
`side13`,
`refPrc13`,
`refDelta13`,
`secKey14_at`,
`secKey14_ts`,
`secKey14_tk`,
`secKey14_yr`,
`secKey14_mn`,
`secKey14_dy`,
`secKey14_xx`,
`secKey14_cp`,
`secType14`,
`ratio14`,
`side14`,
`refPrc14`,
`refDelta14`,
`secKey15_at`,
`secKey15_ts`,
`secKey15_tk`,
`secKey15_yr`,
`secKey15_mn`,
`secKey15_dy`,
`secKey15_xx`,
`secKey15_cp`,
`secType15`,
`ratio15`,
`side15`,
`refPrc15`,
`refDelta15`,
`secKey16_at`,
`secKey16_ts`,
`secKey16_tk`,
`secKey16_yr`,
`secKey16_mn`,
`secKey16_dy`,
`secKey16_xx`,
`secKey16_cp`,
`secType16`,
`ratio16`,
`side16`,
`refPrc16`,
`refDelta16`,
`secKey17_at`,
`secKey17_ts`,
`secKey17_tk`,
`secKey17_yr`,
`secKey17_mn`,
`secKey17_dy`,
`secKey17_xx`,
`secKey17_cp`,
`secType17`,
`ratio17`,
`side17`,
`refPrc17`,
`refDelta17`,
`secKey18_at`,
`secKey18_ts`,
`secKey18_tk`,
`secKey18_yr`,
`secKey18_mn`,
`secKey18_dy`,
`secKey18_xx`,
`secKey18_cp`,
`secType18`,
`ratio18`,
`side18`,
`refPrc18`,
`refDelta18`,
`secKey19_at`,
`secKey19_ts`,
`secKey19_tk`,
`secKey19_yr`,
`secKey19_mn`,
`secKey19_dy`,
`secKey19_xx`,
`secKey19_cp`,
`secType19`,
`ratio19`,
`side19`,
`refPrc19`,
`refDelta19`,
`secKey20_at`,
`secKey20_ts`,
`secKey20_tk`,
`secKey20_yr`,
`secKey20_mn`,
`secKey20_dy`,
`secKey20_xx`,
`secKey20_cp`,
`secType20`,
`ratio20`,
`side20`,
`refPrc20`,
`refDelta20`,
`timestamp`
FROM `SRTrade`.`MsgSecDefRequestGateway`
WHERE
/* Replace with a BIGINT */
`secRequestID` = 1234567890;

INSERT TABLE EXAMPLE QUERY

INSERT INTO `SRTrade`.`MsgSecDefRequestGateway`(
/* Replace with a BIGINT */
`secRequestID`,
/* Replace with a ENUM('None','Covered','Combo') */
`secDefType`,
/* Replace with a VARCHAR(16) */
`accnt`,
/* Replace with a VARCHAR(16) */
`clientFirm`,
/* Replace with a VARCHAR(24) */
`altRequestId`,
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`secKey1_at`,
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */
`secKey1_ts`,
/* Replace with a VARCHAR(12) */
`secKey1_tk`,
/* Replace with a SMALLINT UNSIGNED */
`secKey1_yr`,
/* Replace with a TINYINT UNSIGNED */
`secKey1_mn`,
/* Replace with a TINYINT UNSIGNED */
`secKey1_dy`,
/* Replace with a DOUBLE */
`secKey1_xx`,
/* Replace with a ENUM('Call','Put','Pair') */
`secKey1_cp`,
/* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
`secType1`,
/* Replace with a SMALLINT UNSIGNED */
`ratio1`,
/* Replace with a ENUM('Buy','Sell') */
`side1`,
/* Replace with a DOUBLE */
`refPrc1`,
/* Replace with a FLOAT */
`refDelta1`,
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`secKey2_at`,
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */
`secKey2_ts`,
/* Replace with a VARCHAR(12) */
`secKey2_tk`,
/* Replace with a SMALLINT UNSIGNED */
`secKey2_yr`,
/* Replace with a TINYINT UNSIGNED */
`secKey2_mn`,
/* Replace with a TINYINT UNSIGNED */
`secKey2_dy`,
/* Replace with a DOUBLE */
`secKey2_xx`,
/* Replace with a ENUM('Call','Put','Pair') */
`secKey2_cp`,
/* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
`secType2`,
/* Replace with a SMALLINT UNSIGNED */
`ratio2`,
/* Replace with a ENUM('Buy','Sell') */
`side2`,
/* Replace with a DOUBLE */
`refPrc2`,
/* Replace with a FLOAT */
`refDelta2`,
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`secKey3_at`,
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */
`secKey3_ts`,
/* Replace with a VARCHAR(12) */
`secKey3_tk`,
/* Replace with a SMALLINT UNSIGNED */
`secKey3_yr`,
/* Replace with a TINYINT UNSIGNED */
`secKey3_mn`,
/* Replace with a TINYINT UNSIGNED */
`secKey3_dy`,
/* Replace with a DOUBLE */
`secKey3_xx`,
/* Replace with a ENUM('Call','Put','Pair') */
`secKey3_cp`,
/* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
`secType3`,
/* Replace with a SMALLINT UNSIGNED */
`ratio3`,
/* Replace with a ENUM('Buy','Sell') */
`side3`,
/* Replace with a DOUBLE */
`refPrc3`,
/* Replace with a FLOAT */
`refDelta3`,
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`secKey4_at`,
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */
`secKey4_ts`,
/* Replace with a VARCHAR(12) */
`secKey4_tk`,
/* Replace with a SMALLINT UNSIGNED */
`secKey4_yr`,
/* Replace with a TINYINT UNSIGNED */
`secKey4_mn`,
/* Replace with a TINYINT UNSIGNED */
`secKey4_dy`,
/* Replace with a DOUBLE */
`secKey4_xx`,
/* Replace with a ENUM('Call','Put','Pair') */
`secKey4_cp`,
/* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
`secType4`,
/* Replace with a SMALLINT UNSIGNED */
`ratio4`,
/* Replace with a ENUM('Buy','Sell') */
`side4`,
/* Replace with a DOUBLE */
`refPrc4`,
/* Replace with a FLOAT */
`refDelta4`,
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`secKey5_at`,
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */
`secKey5_ts`,
/* Replace with a VARCHAR(12) */
`secKey5_tk`,
/* Replace with a SMALLINT UNSIGNED */
`secKey5_yr`,
/* Replace with a TINYINT UNSIGNED */
`secKey5_mn`,
/* Replace with a TINYINT UNSIGNED */
`secKey5_dy`,
/* Replace with a DOUBLE */
`secKey5_xx`,
/* Replace with a ENUM('Call','Put','Pair') */
`secKey5_cp`,
/* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
`secType5`,
/* Replace with a SMALLINT UNSIGNED */
`ratio5`,
/* Replace with a ENUM('Buy','Sell') */
`side5`,
/* Replace with a DOUBLE */
`refPrc5`,
/* Replace with a FLOAT */
`refDelta5`,
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`secKey6_at`,
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */
`secKey6_ts`,
/* Replace with a VARCHAR(12) */
`secKey6_tk`,
/* Replace with a SMALLINT UNSIGNED */
`secKey6_yr`,
/* Replace with a TINYINT UNSIGNED */
`secKey6_mn`,
/* Replace with a TINYINT UNSIGNED */
`secKey6_dy`,
/* Replace with a DOUBLE */
`secKey6_xx`,
/* Replace with a ENUM('Call','Put','Pair') */
`secKey6_cp`,
/* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
`secType6`,
/* Replace with a SMALLINT UNSIGNED */
`ratio6`,
/* Replace with a ENUM('Buy','Sell') */
`side6`,
/* Replace with a DOUBLE */
`refPrc6`,
/* Replace with a FLOAT */
`refDelta6`,
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`secKey7_at`,
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */
`secKey7_ts`,
/* Replace with a VARCHAR(12) */
`secKey7_tk`,
/* Replace with a SMALLINT UNSIGNED */
`secKey7_yr`,
/* Replace with a TINYINT UNSIGNED */
`secKey7_mn`,
/* Replace with a TINYINT UNSIGNED */
`secKey7_dy`,
/* Replace with a DOUBLE */
`secKey7_xx`,
/* Replace with a ENUM('Call','Put','Pair') */
`secKey7_cp`,
/* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
`secType7`,
/* Replace with a SMALLINT UNSIGNED */
`ratio7`,
/* Replace with a ENUM('Buy','Sell') */
`side7`,
/* Replace with a DOUBLE */
`refPrc7`,
/* Replace with a FLOAT */
`refDelta7`,
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`secKey8_at`,
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */
`secKey8_ts`,
/* Replace with a VARCHAR(12) */
`secKey8_tk`,
/* Replace with a SMALLINT UNSIGNED */
`secKey8_yr`,
/* Replace with a TINYINT UNSIGNED */
`secKey8_mn`,
/* Replace with a TINYINT UNSIGNED */
`secKey8_dy`,
/* Replace with a DOUBLE */
`secKey8_xx`,
/* Replace with a ENUM('Call','Put','Pair') */
`secKey8_cp`,
/* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
`secType8`,
/* Replace with a SMALLINT UNSIGNED */
`ratio8`,
/* Replace with a ENUM('Buy','Sell') */
`side8`,
/* Replace with a DOUBLE */
`refPrc8`,
/* Replace with a FLOAT */
`refDelta8`,
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`secKey9_at`,
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */
`secKey9_ts`,
/* Replace with a VARCHAR(12) */
`secKey9_tk`,
/* Replace with a SMALLINT UNSIGNED */
`secKey9_yr`,
/* Replace with a TINYINT UNSIGNED */
`secKey9_mn`,
/* Replace with a TINYINT UNSIGNED */
`secKey9_dy`,
/* Replace with a DOUBLE */
`secKey9_xx`,
/* Replace with a ENUM('Call','Put','Pair') */
`secKey9_cp`,
/* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
`secType9`,
/* Replace with a SMALLINT UNSIGNED */
`ratio9`,
/* Replace with a ENUM('Buy','Sell') */
`side9`,
/* Replace with a DOUBLE */
`refPrc9`,
/* Replace with a FLOAT */
`refDelta9`,
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`secKey10_at`,
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */
`secKey10_ts`,
/* Replace with a VARCHAR(12) */
`secKey10_tk`,
/* Replace with a SMALLINT UNSIGNED */
`secKey10_yr`,
/* Replace with a TINYINT UNSIGNED */
`secKey10_mn`,
/* Replace with a TINYINT UNSIGNED */
`secKey10_dy`,
/* Replace with a DOUBLE */
`secKey10_xx`,
/* Replace with a ENUM('Call','Put','Pair') */
`secKey10_cp`,
/* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
`secType10`,
/* Replace with a SMALLINT UNSIGNED */
`ratio10`,
/* Replace with a ENUM('Buy','Sell') */
`side10`,
/* Replace with a DOUBLE */
`refPrc10`,
/* Replace with a FLOAT */
`refDelta10`,
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`secKey11_at`,
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */
`secKey11_ts`,
/* Replace with a VARCHAR(12) */
`secKey11_tk`,
/* Replace with a SMALLINT UNSIGNED */
`secKey11_yr`,
/* Replace with a TINYINT UNSIGNED */
`secKey11_mn`,
/* Replace with a TINYINT UNSIGNED */
`secKey11_dy`,
/* Replace with a DOUBLE */
`secKey11_xx`,
/* Replace with a ENUM('Call','Put','Pair') */
`secKey11_cp`,
/* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
`secType11`,
/* Replace with a SMALLINT UNSIGNED */
`ratio11`,
/* Replace with a ENUM('Buy','Sell') */
`side11`,
/* Replace with a DOUBLE */
`refPrc11`,
/* Replace with a FLOAT */
`refDelta11`,
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`secKey12_at`,
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */
`secKey12_ts`,
/* Replace with a VARCHAR(12) */
`secKey12_tk`,
/* Replace with a SMALLINT UNSIGNED */
`secKey12_yr`,
/* Replace with a TINYINT UNSIGNED */
`secKey12_mn`,
/* Replace with a TINYINT UNSIGNED */
`secKey12_dy`,
/* Replace with a DOUBLE */
`secKey12_xx`,
/* Replace with a ENUM('Call','Put','Pair') */
`secKey12_cp`,
/* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
`secType12`,
/* Replace with a SMALLINT UNSIGNED */
`ratio12`,
/* Replace with a ENUM('Buy','Sell') */
`side12`,
/* Replace with a DOUBLE */
`refPrc12`,
/* Replace with a FLOAT */
`refDelta12`,
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`secKey13_at`,
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */
`secKey13_ts`,
/* Replace with a VARCHAR(12) */
`secKey13_tk`,
/* Replace with a SMALLINT UNSIGNED */
`secKey13_yr`,
/* Replace with a TINYINT UNSIGNED */
`secKey13_mn`,
/* Replace with a TINYINT UNSIGNED */
`secKey13_dy`,
/* Replace with a DOUBLE */
`secKey13_xx`,
/* Replace with a ENUM('Call','Put','Pair') */
`secKey13_cp`,
/* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
`secType13`,
/* Replace with a SMALLINT UNSIGNED */
`ratio13`,
/* Replace with a ENUM('Buy','Sell') */
`side13`,
/* Replace with a DOUBLE */
`refPrc13`,
/* Replace with a FLOAT */
`refDelta13`,
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`secKey14_at`,
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */
`secKey14_ts`,
/* Replace with a VARCHAR(12) */
`secKey14_tk`,
/* Replace with a SMALLINT UNSIGNED */
`secKey14_yr`,
/* Replace with a TINYINT UNSIGNED */
`secKey14_mn`,
/* Replace with a TINYINT UNSIGNED */
`secKey14_dy`,
/* Replace with a DOUBLE */
`secKey14_xx`,
/* Replace with a ENUM('Call','Put','Pair') */
`secKey14_cp`,
/* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
`secType14`,
/* Replace with a SMALLINT UNSIGNED */
`ratio14`,
/* Replace with a ENUM('Buy','Sell') */
`side14`,
/* Replace with a DOUBLE */
`refPrc14`,
/* Replace with a FLOAT */
`refDelta14`,
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`secKey15_at`,
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */
`secKey15_ts`,
/* Replace with a VARCHAR(12) */
`secKey15_tk`,
/* Replace with a SMALLINT UNSIGNED */
`secKey15_yr`,
/* Replace with a TINYINT UNSIGNED */
`secKey15_mn`,
/* Replace with a TINYINT UNSIGNED */
`secKey15_dy`,
/* Replace with a DOUBLE */
`secKey15_xx`,
/* Replace with a ENUM('Call','Put','Pair') */
`secKey15_cp`,
/* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
`secType15`,
/* Replace with a SMALLINT UNSIGNED */
`ratio15`,
/* Replace with a ENUM('Buy','Sell') */
`side15`,
/* Replace with a DOUBLE */
`refPrc15`,
/* Replace with a FLOAT */
`refDelta15`,
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`secKey16_at`,
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */
`secKey16_ts`,
/* Replace with a VARCHAR(12) */
`secKey16_tk`,
/* Replace with a SMALLINT UNSIGNED */
`secKey16_yr`,
/* Replace with a TINYINT UNSIGNED */
`secKey16_mn`,
/* Replace with a TINYINT UNSIGNED */
`secKey16_dy`,
/* Replace with a DOUBLE */
`secKey16_xx`,
/* Replace with a ENUM('Call','Put','Pair') */
`secKey16_cp`,
/* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
`secType16`,
/* Replace with a SMALLINT UNSIGNED */
`ratio16`,
/* Replace with a ENUM('Buy','Sell') */
`side16`,
/* Replace with a DOUBLE */
`refPrc16`,
/* Replace with a FLOAT */
`refDelta16`,
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`secKey17_at`,
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */
`secKey17_ts`,
/* Replace with a VARCHAR(12) */
`secKey17_tk`,
/* Replace with a SMALLINT UNSIGNED */
`secKey17_yr`,
/* Replace with a TINYINT UNSIGNED */
`secKey17_mn`,
/* Replace with a TINYINT UNSIGNED */
`secKey17_dy`,
/* Replace with a DOUBLE */
`secKey17_xx`,
/* Replace with a ENUM('Call','Put','Pair') */
`secKey17_cp`,
/* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
`secType17`,
/* Replace with a SMALLINT UNSIGNED */
`ratio17`,
/* Replace with a ENUM('Buy','Sell') */
`side17`,
/* Replace with a DOUBLE */
`refPrc17`,
/* Replace with a FLOAT */
`refDelta17`,
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`secKey18_at`,
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */
`secKey18_ts`,
/* Replace with a VARCHAR(12) */
`secKey18_tk`,
/* Replace with a SMALLINT UNSIGNED */
`secKey18_yr`,
/* Replace with a TINYINT UNSIGNED */
`secKey18_mn`,
/* Replace with a TINYINT UNSIGNED */
`secKey18_dy`,
/* Replace with a DOUBLE */
`secKey18_xx`,
/* Replace with a ENUM('Call','Put','Pair') */
`secKey18_cp`,
/* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
`secType18`,
/* Replace with a SMALLINT UNSIGNED */
`ratio18`,
/* Replace with a ENUM('Buy','Sell') */
`side18`,
/* Replace with a DOUBLE */
`refPrc18`,
/* Replace with a FLOAT */
`refDelta18`,
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`secKey19_at`,
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */
`secKey19_ts`,
/* Replace with a VARCHAR(12) */
`secKey19_tk`,
/* Replace with a SMALLINT UNSIGNED */
`secKey19_yr`,
/* Replace with a TINYINT UNSIGNED */
`secKey19_mn`,
/* Replace with a TINYINT UNSIGNED */
`secKey19_dy`,
/* Replace with a DOUBLE */
`secKey19_xx`,
/* Replace with a ENUM('Call','Put','Pair') */
`secKey19_cp`,
/* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
`secType19`,
/* Replace with a SMALLINT UNSIGNED */
`ratio19`,
/* Replace with a ENUM('Buy','Sell') */
`side19`,
/* Replace with a DOUBLE */
`refPrc19`,
/* Replace with a FLOAT */
`refDelta19`,
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`secKey20_at`,
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */
`secKey20_ts`,
/* Replace with a VARCHAR(12) */
`secKey20_tk`,
/* Replace with a SMALLINT UNSIGNED */
`secKey20_yr`,
/* Replace with a TINYINT UNSIGNED */
`secKey20_mn`,
/* Replace with a TINYINT UNSIGNED */
`secKey20_dy`,
/* Replace with a DOUBLE */
`secKey20_xx`,
/* Replace with a ENUM('Call','Put','Pair') */
`secKey20_cp`,
/* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
`secType20`,
/* Replace with a SMALLINT UNSIGNED */
`ratio20`,
/* Replace with a ENUM('Buy','Sell') */
`side20`,
/* Replace with a DOUBLE */
`refPrc20`,
/* Replace with a FLOAT */
`refDelta20`,
/* Replace with a DATETIME(6) */
`timestamp`
)
VALUES(
1234567890,
'None',
'Example_accnt',
'Example_clientFirm',
'Example_altRequestId',
'None',
'None',
'Example_secKey1_tk',
123,
1,
1,
4.56,
'Call',
'None',
123,
'Buy',
4.56,
1.23,
'None',
'None',
'Example_secKey2_tk',
123,
1,
1,
4.56,
'Call',
'None',
123,
'Buy',
4.56,
1.23,
'None',
'None',
'Example_secKey3_tk',
123,
1,
1,
4.56,
'Call',
'None',
123,
'Buy',
4.56,
1.23,
'None',
'None',
'Example_secKey4_tk',
123,
1,
1,
4.56,
'Call',
'None',
123,
'Buy',
4.56,
1.23,
'None',
'None',
'Example_secKey5_tk',
123,
1,
1,
4.56,
'Call',
'None',
123,
'Buy',
4.56,
1.23,
'None',
'None',
'Example_secKey6_tk',
123,
1,
1,
4.56,
'Call',
'None',
123,
'Buy',
4.56,
1.23,
'None',
'None',
'Example_secKey7_tk',
123,
1,
1,
4.56,
'Call',
'None',
123,
'Buy',
4.56,
1.23,
'None',
'None',
'Example_secKey8_tk',
123,
1,
1,
4.56,
'Call',
'None',
123,
'Buy',
4.56,
1.23,
'None',
'None',
'Example_secKey9_tk',
123,
1,
1,
4.56,
'Call',
'None',
123,
'Buy',
4.56,
1.23,
'None',
'None',
'Example_secKey10_tk',
123,
1,
1,
4.56,
'Call',
'None',
123,
'Buy',
4.56,
1.23,
'None',
'None',
'Example_secKey11_tk',
123,
1,
1,
4.56,
'Call',
'None',
123,
'Buy',
4.56,
1.23,
'None',
'None',
'Example_secKey12_tk',
123,
1,
1,
4.56,
'Call',
'None',
123,
'Buy',
4.56,
1.23,
'None',
'None',
'Example_secKey13_tk',
123,
1,
1,
4.56,
'Call',
'None',
123,
'Buy',
4.56,
1.23,
'None',
'None',
'Example_secKey14_tk',
123,
1,
1,
4.56,
'Call',
'None',
123,
'Buy',
4.56,
1.23,
'None',
'None',
'Example_secKey15_tk',
123,
1,
1,
4.56,
'Call',
'None',
123,
'Buy',
4.56,
1.23,
'None',
'None',
'Example_secKey16_tk',
123,
1,
1,
4.56,
'Call',
'None',
123,
'Buy',
4.56,
1.23,
'None',
'None',
'Example_secKey17_tk',
123,
1,
1,
4.56,
'Call',
'None',
123,
'Buy',
4.56,
1.23,
'None',
'None',
'Example_secKey18_tk',
123,
1,
1,
4.56,
'Call',
'None',
123,
'Buy',
4.56,
1.23,
'None',
'None',
'Example_secKey19_tk',
123,
1,
1,
4.56,
'Call',
'None',
123,
'Buy',
4.56,
1.23,
'None',
'None',
'Example_secKey20_tk',
123,
1,
1,
4.56,
'Call',
'None',
123,
'Buy',
4.56,
1.23,
'2022-01-01 12:34:56.000000'
);

Doc Columns Query

SELECT * FROM SRTrade.doccolumns WHERE TABLE_NAME='SecDefRequestGateway' ORDER BY ordinal_position ASC;